Data Reconciliation utilities

These reports are designed for designed for month-end close analysis.

Accessing these reports

The reports listed in this section are located in \Axiom\Reports Library\Management Reporting Utilities\Data Reconciliation. For instructions, see Browsing the Report Library.

You can also access them from the Bud Admin task pane. In the Financial Reporting section, click Financial Utilities > Data Reconciliation.

Acct Standards Review

Use this report to map standardized data for accounts in your organization to KHA Standard Class codes.

Click image to view full size

BiWeekly Payroll Reconciliation report

After the payroll file is loaded, run the Biweekly Payroll Reconciliation report.

Using the loaded import file, total the dollars and hours from the import file, and enter the totals into the BiWeekly Payroll Reconciliation report to see if your check totals from your import file match what was loaded in to Axiom.

Click image to view full size

If your dollars and hours for the loaded period matches the Grand Total, the data is reconciled, and you can move on to either loading another payroll for the current month or running the Payroll Accrual utility to accrue your biweekly payroll to a monthly payroll.

Consolidations and Eliminations

This is a save to database report that allows you to input eliminations for your Financial database.

Click image to view full size

Dept Standards Review

Use this report to map standardized data for departments in your organization to KHA Standard Class codes.

Click image to view full size

Entity Standards Review

Use this report to map standardized data for entities in your organization to KHA Standard Class codes.

Click image to view full size

Jobcode Standards Review

Use this report to map standardized data for job codes in your organization to KHA Standard Class codes.

Click image to view full size

Monthly RevUsage Reconciliation

After all data is loaded, run the Monthly RevUsage Reconciliation. This report shows the IPVolume, IPRevenue, OPVolume, and OPRvenue by department for each month.

Using the import file that was loaded, total the Volumes and Revenue dollars from the import file, and key the totals into the Monthly RevUsage Reconciliation report to see if your check totals from your import file match what was loaded in to Axiom.

Click image to view full size

If your dollars and volumes for the period loaded matches the Grand Total, the data is reconciled. If you use RevUsage volumes to calculate statistics for productivity, you can move forward to summarize your IP\OP volumes from your RevUsage data table (ACT_RU_20XX) to your Financial data table (ACT20XX) using the Summarize CDM Statistics utility.

Paytype Standards Review

Use this report to map standardized data for pay types in your organization to KHA Standard Class codes.

Click image to view full size

Reconcile GL to GLTransactions report

If you load subledger detail into Axiom, such as Accounts Payable (AP), Accrued Receipts (AR), Materials Management (MM) and Journal Entries (JE), we have a reconciliation utility that ties the subledger data back to the ledger data (ACT20XX). This report confirms that the data loaded to the GL matches the data loaded to Journal Entry (JE) detail. It also compares the JE Detail to AP, MM, AR transactions to make sure the data is in balance.

TIP: Your Syntellis Implementation Consultant will help you set up this report during implementation.

Click image to view full size

NOTE: Use the Reconcile GL to RevUsage report to reconcile your charge master data for Inpatient and Outpatient between the Financial data source (ACT20XX) and the RevUsage data set (ACT_RU_20XX). Manual adjusting journal entries outside of the source system will cause reconciling variances to the General Ledger RevUsage data so do not use this report regularly. The report is located in the Reports Library in the Management Reporting Utilities > Data Reconciliation folder.

Reconcile GL to Pay12 to Pay27 report

Use this report to compare the Current Year Gross Revenue in the Financial tables to the RevUsage tables.

Click image to view full size

Reconcile GL to Rev Usage report

Use to reconcile GL revenue data in the Financial tables to the Revenue and Usage data imported into the database on a monthly and year-to-date basis. The desired result for this report is to show a zero variance.

Click image to view full size